﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MobileWalletDBDataSet" targetNamespace="http://tempuri.org/MobileWalletDBDataSet.xsd" xmlns:mstns="http://tempuri.org/MobileWalletDBDataSet.xsd" xmlns="http://tempuri.org/MobileWalletDBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Data Source=.\Data\MobileWalletDB.sdf" IsAppSettingsProperty="false" Modifier="Assembly" Name="MobileWalletDBConnectionString" ParameterPrefix="@" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PayCategoryTableAdapter" GeneratorDataComponentClassName="PayCategoryTableAdapter" Name="PayCategory" UserDataComponentName="PayCategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MobileWalletDBConnectionString" DbObjectName="PayCategory" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [PayCategory] WHERE (([CategoryId] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [PayCategory] ([CategoryId], [CategoryTitle], [CategoryDetail], [CategoryType]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryDetail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="CategoryType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   CategoryId, CategoryTitle, CategoryDetail, CategoryType
FROM      PayCategory
WHERE   (CategoryType = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [PayCategory] SET [CategoryId] = @p1, [CategoryTitle] = @p2, [CategoryDetail] = @p3, [CategoryType] = @p4 WHERE (([CategoryId] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryTitle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryDetail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="CategoryType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryId" DataSetColumn="CategoryId" />
              <Mapping SourceColumn="CategoryTitle" DataSetColumn="CategoryTitle" />
              <Mapping SourceColumn="CategoryDetail" DataSetColumn="CategoryDetail" />
              <Mapping SourceColumn="CategoryType" DataSetColumn="CategoryType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PayDetailTableAdapter" GeneratorDataComponentClassName="PayDetailTableAdapter" Name="PayDetail" UserDataComponentName="PayDetailTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MobileWalletDBConnectionString" DbObjectName="PayDetail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [PayDetail] WHERE (([DetailId] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DetailId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [PayDetail] ([DetailId], [Title], [Description], [HappendDay], [Amount], [CategoryId]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DetailId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HappendDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   DetailId, Title, Description, HappendDay, Amount, CategoryId
FROM      PayDetail</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [PayDetail] SET [DetailId] = @p1, [Title] = @p2, [Description] = @p3, [HappendDay] = @p4, [Amount] = @p5, [CategoryId] = @p6 WHERE (([DetailId] = @p7))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DetailId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="HappendDay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Amount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DetailId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DetailId" DataSetColumn="DetailId" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="HappendDay" DataSetColumn="HappendDay" />
              <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
              <Mapping SourceColumn="CategoryId" DataSetColumn="CategoryId" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RunningAccountDataTableTableAdapter" GeneratorDataComponentClassName="RunningAccountDataTableTableAdapter" Name="RunningAccountDataTable" UserDataComponentName="RunningAccountDataTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MobileWalletDBConnectionString" DbObjectName="PayDetail" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        PayDetail.HappendDay, (CASE WHEN CategoryType = 1 THEN 'Spend' ELSE 'Earn' END) AS CategoryType, PayDetail.Amount, PayDetail.Title
FROM            PayCategory INNER JOIN
                         PayDetail ON PayCategory.CategoryId = PayDetail.CategoryId</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="HappendDay" DataSetColumn="HappendDay" />
              <Mapping SourceColumn="CategoryType" DataSetColumn="CategoryType" />
              <Mapping SourceColumn="Amount" DataSetColumn="Amount" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MobileWalletDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="MobileWalletDBDataSet" msprop:Generator_DataSetName="MobileWalletDBDataSet" msprop:EnableTableAdapterManager="False">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PayCategory" msprop:Generator_UserTableName="PayCategory" msprop:Generator_RowDeletedName="PayCategoryRowDeleted" msprop:Generator_RowChangedName="PayCategoryRowChanged" msprop:Generator_RowClassName="PayCategoryRow" msprop:Generator_RowChangingName="PayCategoryRowChanging" msprop:Generator_RowEvArgName="PayCategoryRowChangeEvent" msprop:Generator_RowEvHandlerName="PayCategoryRowChangeEventHandler" msprop:Generator_TableClassName="PayCategoryDataTable" msprop:Generator_TableVarName="tablePayCategory" msprop:Generator_RowDeletingName="PayCategoryRowDeleting" msprop:Generator_TablePropName="PayCategory">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="CategoryId" msprop:Generator_ColumnPropNameInRow="CategoryId" msprop:Generator_ColumnVarNameInTable="columnCategoryId" msprop:Generator_ColumnPropNameInTable="CategoryIdColumn" type="xs:string" />
              <xs:element name="CategoryTitle" msprop:Generator_UserColumnName="CategoryTitle" msprop:Generator_ColumnPropNameInRow="CategoryTitle" msprop:Generator_ColumnVarNameInTable="columnCategoryTitle" msprop:Generator_ColumnPropNameInTable="CategoryTitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CategoryDetail" msprop:Generator_UserColumnName="CategoryDetail" msprop:Generator_ColumnVarNameInTable="columnCategoryDetail" msprop:Generator_ColumnPropNameInRow="CategoryDetail" msprop:Generator_ColumnPropNameInTable="CategoryDetailColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CategoryType" msprop:Generator_UserColumnName="CategoryType" msprop:Generator_ColumnVarNameInTable="columnCategoryType" msprop:Generator_ColumnPropNameInRow="CategoryType" msprop:Generator_ColumnPropNameInTable="CategoryTypeColumn" type="xs:unsignedByte" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PayDetail" msprop:Generator_UserTableName="PayDetail" msprop:Generator_RowDeletedName="PayDetailRowDeleted" msprop:Generator_RowChangedName="PayDetailRowChanged" msprop:Generator_RowClassName="PayDetailRow" msprop:Generator_RowChangingName="PayDetailRowChanging" msprop:Generator_RowEvArgName="PayDetailRowChangeEvent" msprop:Generator_RowEvHandlerName="PayDetailRowChangeEventHandler" msprop:Generator_TableClassName="PayDetailDataTable" msprop:Generator_TableVarName="tablePayDetail" msprop:Generator_RowDeletingName="PayDetailRowDeleting" msprop:Generator_TablePropName="PayDetail">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DetailId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="DetailId" msprop:Generator_ColumnPropNameInRow="DetailId" msprop:Generator_ColumnVarNameInTable="columnDetailId" msprop:Generator_ColumnPropNameInTable="DetailIdColumn" type="xs:string" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HappendDay" msprop:Generator_UserColumnName="HappendDay" msprop:Generator_ColumnPropNameInRow="HappendDay" msprop:Generator_ColumnVarNameInTable="columnHappendDay" msprop:Generator_ColumnPropNameInTable="HappendDayColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Amount" msprop:Generator_UserColumnName="Amount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInTable="AmountColumn" type="xs:decimal" />
              <xs:element name="CategoryId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="CategoryId" msprop:Generator_ColumnPropNameInRow="CategoryId" msprop:Generator_ColumnVarNameInTable="columnCategoryId" msprop:Generator_ColumnPropNameInTable="CategoryIdColumn" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RunningAccountDataTable" msprop:Generator_UserTableName="RunningAccountDataTable" msprop:Generator_RowDeletedName="RunningAccountDataTableRowDeleted" msprop:Generator_RowChangedName="RunningAccountDataTableRowChanged" msprop:Generator_RowClassName="RunningAccountDataTableRow" msprop:Generator_RowChangingName="RunningAccountDataTableRowChanging" msprop:Generator_RowEvArgName="RunningAccountDataTableRowChangeEvent" msprop:Generator_RowEvHandlerName="RunningAccountDataTableRowChangeEventHandler" msprop:Generator_TableClassName="RunningAccountDataTableDataTable" msprop:Generator_TableVarName="tableRunningAccountDataTable" msprop:Generator_RowDeletingName="RunningAccountDataTableRowDeleting" msprop:Generator_TablePropName="RunningAccountDataTable">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="HappendDay" msdata:ReadOnly="true" msprop:Generator_UserColumnName="HappendDay" msprop:Generator_ColumnPropNameInRow="HappendDay" msprop:Generator_ColumnVarNameInTable="columnHappendDay" msprop:Generator_ColumnPropNameInTable="HappendDayColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CategoryType" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CategoryType" msprop:Generator_ColumnPropNameInRow="CategoryType" msprop:Generator_ColumnVarNameInTable="columnCategoryType" msprop:Generator_ColumnPropNameInTable="CategoryTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Amount" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Amount" msprop:Generator_ColumnPropNameInRow="Amount" msprop:Generator_ColumnVarNameInTable="columnAmount" msprop:Generator_ColumnPropNameInTable="AmountColumn" type="xs:decimal" />
              <xs:element name="Title" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PayCategory" />
      <xs:field xpath="mstns:CategoryId" />
    </xs:unique>
    <xs:unique name="PayDetail_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PayDetail" />
      <xs:field xpath="mstns:DetailId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="DetailCategory" msdata:parent="PayCategory" msdata:child="PayDetail" msdata:parentkey="CategoryId" msdata:childkey="CategoryId" msprop:Generator_UserRelationName="DetailCategory" msprop:Generator_RelationVarName="relationDetailCategory" msprop:Generator_UserChildTable="PayDetail" msprop:Generator_UserParentTable="PayCategory" msprop:Generator_ParentPropName="PayCategoryRow" msprop:Generator_ChildPropName="GetPayDetailRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>